Quick facts: SSRS reports

iMIS natively supports SQL Server Reporting Services (SSRS) for both static and dynamic reporting capability with SQL Server databases. Reporting Services includes everything you need to create, distribute, and manage reports.

Important: iMIS supports Crystal Reports, but all new iMIS reports use SSRS.

What do I need to license or buy?

Nothing! iMIS installs the SSRS Report Viewer control for ASP.NET applications that comes with Microsoft Visual Studio. iMIS uses the Report Viewer control, which offers a document map, jump-to-page, zoom, and search. iMIS enables the control’s built-in report navigation (pagination), parent report support, and export functionality, including Excel (XLS) and PDF formats.

■    Microsoft freely distributes the Report Viewer control

■    You can edit the XML-based report format in any text editor

■    Visual report designers, Report Builder and Business Intelligence Development Studio, are free for download

How do I run reports in iMIS?

■    Generate a default SSRS report on the fly using the Report command in IQA.

■    Browse to a content record that has an SSRS Report iPart configured on it.

■    Open a navigation item that lists all of the reports in a given folder, and select one.

■    Run SSRS reports directly from the Document System.

Where to find samples: In the Document System, go to $\Samples\ReportingServices to access example SSRS reports (each of which has a query, a template, and a run-time report).